<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
	<p>Create Table</p>
	<form action="/db_labb1/TestServlet" METHOD="GET">
		TableName:<input type="text" name="CreatetableName"><br>
		Variable1:<input type="text" name="var1name">
		<select name="var1type">
			<option>Int</option>
			<option>varchar</option>
			<option>Float</option>
		</select>
		<br>
		Variable2:<input type="text" name="var2name">
		<select name="var2type">
			<option>Int</option>
			<option>varchar</option>
			<option>Float</option>
		</select>
		<br>
		Variable3:<input type="text" name="var3name">
		<select name="var3type">
			<option>Int</option>
			<option>varchar</option>
			<option>Float</option>
		</select>
		<br>
		Variable4:<input type="text" name="var4name">
		<select name="var4type">
			<option>Int</option>
			<option>varchar</option>
			<option>Float</option>
		</select>
		<br>
		<input type="submit" value="CreateTable!" />
	</form>
	
	<br>
	
	<p>Insert Blob v2</p>
	<fieldset>
        <legend>Upload Blob</legend>
        <form action="/db_labb1/TestServlet" method="post" enctype="multipart/form-data">
            <label for="filename_1">File: </label>
            <input id="filename_1" type="file" name="filename_1" size="50"/><br/>
            <input type="submit" value="Upload Blob"/>
        </form>
    </fieldset>
	
	
	<br>
	
	<p>Get data</p>
	<form action="/db_labb1/TestServlet" METHOD="GET">
		TableName:<input type="text" name="getDataTableName"><br>
		Data:<input type="text" name="data"><br>
		<input type="submit" value="GetData!" />
	</form>
	
	<br>
	<p>Insert Data</p>
	<form action="/db_labb1/TestServlet" METHOD="GET">
		TableName:<input type="text" name="InsertTableName"><br>
		Variable1:
		<select name="var1type">
			<option>Int</option>
			<option>varchar</option>
			<option>Float</option>
		</select>
		Name:<input type="text" name="var1name">value:<input type="text" name="var1value">
		<br>
		Variable2:
		<select name="var2type">
			<option>Int</option>
			<option>varchar</option>
			<option>Float</option>
		</select>
		Name:<input type="text" name="var2name">value:<input type="text" name="var2value">
		<br>
		Variable3:
		<select name="var3type">
			<option>Int</option>
			<option>varchar</option>
			<option>Float</option>
		</select>
		Name:<input type="text" name="var3name">value:<input type="text" name="var3value">
		<br>
		Variable4:
		<select name="var4type">
			<option>Int</option>
			<option>varchar</option>
			<option>Float</option>
		</select>
		Name:<input type="text" name="var4name">value:<input type="text" name="var4value">
		<br>
		<input type="submit" value="InsertData!" />
	</form>
	
	
	
	
	<p>Delete data</p>
	<form action="/db_labb1/TestServlet" METHOD="GET">
		TableName:<input type="text" name="deleteDataTableName"><br>
		Data:<input type="text" name="data"><br>
		<input type="submit" value="DeleteData!" />
	</form>


</body>
</html>